Carson Penticuff
Carson Penticuff
Reactions
-
Re: Add Months to Date formula?
You are missing a closing parenthesis on the first line - ISDATE([Payment Start Date]@row, - and you have an extra closing parenthesis at the very end. This should fix it: =IF(AND(ISDATE([Payment Sta…1 · -
Re: Add Months to Date formula?
Slight edit added... Dealing with months is somewhat tricky. "How" do you want to add the months? Here are a few examples of ways to deal with months: With a start date of 01/31/2024 and ad…2 · -
Re: Nested IF Formula
See if this works for you. This ignores the days and year and simply matches the quarter based on the month. =IFERROR(IF(AND(MONTH([End Date]@row) >= 9, MONTH([End Date]@row) <= 11), "Q1&q…1 · -
Re: Can I get a syntax check of the following Credit Amount Formula?
You can simplify your Rebill formula quite a bit: =IF([Type of Credit]@row <> "Rebill-Invoice-Error", "Not applicable ", IF(OR([Invoice 1 Status (Dropdown)]@row = "Cred…1 · -
Re: How to only edit a cell if it is negative
You can just wrap the entire formula you are using in ABS() to return the absolute value.1 ·
